package com.flyco.modules.pms.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.flyco.poi.excel.annotation.Excel;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import java.io.Serializable;

/**
 * @Description: SKU
 * @Author: flyco
 * @Date:   2019-11-22
 * @Version: V1.0
 */
@Data
@TableName("pms_sku_stock")
public class PmsSkuStock implements Serializable {
    private static final long serialVersionUID = 1L;

	/**商品SKUID*/
	@TableId(type = IdType.AUTO)
	private Long id;
	/**门店编号*/
	@Excel(name = "门店编号", width = 15)
	private Long storeId;
	/**商品id*/
	private Long productId;
	/**sku编码*/
    @Excel(name = "sku编码", width = 15)
	private String skuCode;
	/**价格*/
    @Excel(name = "价格", width = 15)
	private java.math.BigDecimal price;
	/**库存*/
    @Excel(name = "库存", width = 15)
	private Integer stock;
	/**预警库存*/
    @Excel(name = "预警库存", width = 15)
	private Integer lowStock;
	/**销售属性1*/
    @Excel(name = "销售属性1", width = 15)
	private String sp1;
	/**销售属性2*/
    @Excel(name = "销售属性2", width = 15)
	private String sp2;
	/**销售属性3*/
    @Excel(name = "销售属性3", width = 15)
	private String sp3;
	/**展示图片*/
    @Excel(name = "展示图片", width = 15)
	private String pic;
	/**销量*/
    @Excel(name = "销量", width = 15)
	private Integer sale;
	/**单品促销价格*/
	@Excel(name = "单品促销价格", width = 15)
	private java.math.BigDecimal promotionPrice;
	/**锁定库存*/
	@Excel(name = "锁定库存", width = 15)
	private Integer lockStock;
	/**创建人*/
	@Excel(name = "创建人", width = 15)
	private String createBy;
	/**创建时间*/
	@Excel(name = "创建时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
	@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
	private java.util.Date createTime;
	/**更新人*/
    @Excel(name = "更新人", width = 15)
	private String updateBy;
	/**更新时间*/
	@Excel(name = "更新时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
	@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
	private java.util.Date updateTime;
	/**当前库存*/
	@TableField(exist = false)
	private Integer currentStock;

	/**新增时，批量选门店*/
	@TableField(exist = false)
	private String storeIds;

	/**门店名称*/
	@TableField(exist = false)
	private String storeId_dictText;
}
